﻿if exists (select 1
            from  sysobjects
           where  id = object_id('GXBZ_EMR_CYJL')
            and   type = 'U')
   drop table GXBZ_EMR_CYJL
go

/*==============================================================*/
/* Table: GXBZ_EMR_CYJL                                         */
/*==============================================================*/
create table GXBZ_EMR_CYJL (
   ZYLSH                varchar(64)          not null,
   XGBZ                 varchar(1)           not null,
   GRJBXXBSH            varchar(64)          not null,
   CXJMJKDABH           varchar(17)          not null,
   CISID                char(10)             null,
   KFSSGH               varchar(64)          null,
   KFYSXM               varchar(30)          null,
   WDGLJGDM             varchar(22)          null,
   WDGLJGMC             varchar(70)          null,
   ZRYSBM               varchar(64)          null,
   ZRYSXM               varchar(30)          null,
   ZRYSQMSJ             datetime             null,
   ZZYSBM               varchar(64)          null,
   ZZYSXM               varchar(30)          null,
   ZYYSBM               varchar(64)          null,
   ZYYSXM               varchar(30)          null,
   BCH                  varchar(20)          null,
   BCHMC                varchar(100)         null,
   BFH                  varchar(20)          null,
   BFHMC                varchar(100)         null,
   KSBM                 varchar(64)          null,
   KSMC                 varchar(32)          null,
   CYBQBM               varchar(20)          null,
   CYBQMC               varchar(100)         null,
   YLJGDM               varchar(22)          null,
   YLJGMC               varchar(70)          null,
   ZYJKQK               varchar(1024)        null,
   RYZDBM               varchar(10)          null,
   RYRQSJ               datetime             null,
   YXFZJCJG             varchar(1024)        null,
   ZYSZGCJG             varchar(1024)        null,
   ZZZF                 varchar(100)         null,
   ZLGCMS               varchar(1024)        null,
   ZYJZFF               varchar(100)         null,
   ZYYYFF               varchar(100)         null,
   CYQK                 varchar(1024)        null,
   CYRQSJ               datetime             null,
   CXYZDDM              varchar(10)          null,
   CXYZDMC              varchar(100)         null,
   CZYBMMC              varchar(100)         null,
   CZYBMDM              varchar(10)          null,
   CZYZHMC              varchar(100)         null,
   CZYZHDM              varchar(10)          null,
   CYZZTZ               varchar(1024)        null,
   CYYZ                 varchar(1024)        null,
   MJ                   varchar(16)          not null,
   TBRQ                 datetime             not null,
   SCZT                 varchar(1)           not null,
   CS_JYBZ              int                  not null,
   SCSJ                 datetime             not null,
   constraint PK_GXBZ_EMR_CYJL primary key (ZYLSH, XGBZ)
)
go
